Which elements of a worksheet can be protected from accidental modification?
1.Contents
2.Objects
3.Scenarios
4.All of above
B7:B9 indicates
1.Cells B7 and cell B9 only.
2.Cells B7 through B9
3.Cell B8 only
4.None of above
How many worksheets can a workbook have?
1.3
2.8
3.255
4.None of above
In Excel a Data Series is defined as what?
1.A type of chart.
2.A cell reference.
3. A collection of related data
4.A division of results
In the formula which symbol specifies the fixed columns or rows?
1.$
2.*
3.%
4.&
Which key do you press to check spelling?
1.F3
2.F5
3.F7
4.F9
A numeric value can be treated as label value if …… precedes it.
1.Apostrophe
2.Exclamation
3.Hash
4.Tilde
A __________ is a grid with labeled columns and rows.
1.Dialog box
2.Worksheet
3.Clipboard
4.Toolbar
An Excel Workbook is a collection of …….
1.Workbooks
2.Worksheets
3.Charts
4. Worksheets and Charts
Concatenation of text can be done using
1.Apostrophe
2. Exclamation
3.Hash
4.Ampersand
Excel displays the current cell address in the ……….
1.Formula bar
2. Status Bar
3.Name Box
4.Title Bar
Getting data from a cell located in a different sheet is called
1.Accessing
2.Referencing
3.Updating
4.Functioning
How do you display current date and time in MS Excel?
1.date
2.Today
3.now
4.time
How do you display current date only in MS Excel?
1.date
2.Today
3.now
4.time
How do you rearrange the data in ascending or descending order?
1.Data Sort
2.Data Form
3.Data Table
4. Data Subtotals
How do you wrap the text in a cell?
1.Format cells font
2.Format cells protection
3.format cells number
4.Format cells alignment
In Excel the Fill Color button on the Formatting toolbar is used for what?
1.To insert a background.
2.To add borders.
3. To select a distribution of figures.
4.To add shading or color to a cell range.
In EXCEL you can sum a large range of data by simply selecting a tool button called …..?
1.AutoFill
2.Auto correct
3.Auto sum
4.Auto format
In help menu of Excel which of the following tabs are found?
1.Contents tab
2.Answer Wizard tab
3.Index tab
4.All of above
Which menu option can be used to split windows into two?
1.Format -> Window
2.View -> Window-> Split
3. Window -> Split
4.View –> Split
Microsoft Excel is a powerful………..
1. Word processing package
2.Spreadsheet package
3.Communication S/W Package
4.DBMS package
MS-EXCEL is based on ……….?
1.WINDOWS
2.DOS
3.UNIX
4.OS/2
Multiple calculations can be made in a single formula using…..
1.Standard Formulas
2.Array Formula
3.Complex Formulas
4. Smart Formula
The active cell:
1. is defined by a bold border around the cell.
2.Receives the data the user enters.
3.It is the formula bar
4.Only A and B.
The Cancel and Enter buttons appear in the
1.Title bar
2.Formula bar
3. Menu bar
4.Sheet tabs
The first cell in EXCEL worksheet is labeled as
1.AA
2.A1
3.Aa
4.A0
The spelling dialog box can be involved by choosing spelling from ________ menu.
1.insert
2.file
3.tools
4.view
To record a sequence of keystrokes and mouse actions to play back later we use
1. Media player
2.Sound Recorder
3.Calculator
4.Macro Recorder
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
1.ROUND
2.FACT
3.MOD
4.DIV
To select an entire column in MS-EXCEL press?
1.CTRL + C
2.CTRL + Arrow key
3.CTRL + S
4.None of above
We can save and protect the workbook by
1.Write Reservation Password
2.Protection Password
3.Read-only Recommended
4.Any of the above
What are the tabs that appear at the bottom of each workbook called?
1.Reference tabs
2.Position tabs
3.Location tabs
4. Sheet tabs
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
1.XY Chart
2.Line Chart
3.Pie Chart
4.Column Chart
What do you mean by a Workspace?
1.Group of Columns
2.Group of Worksheets
3.Group of Rows
4.Group of Workbooks
What does COUNTA () function do?
1.counts cells having alphabets
2.counts empty cells
3.counts cells having number
4.counts non-empty cells
What happens when dollar signs ($) are entered in a cell address?
1.An absolute cell address is created.
2.Cell address will change when it is copied to another cell.
3.The sheet tab is changed.
4.The status bar does not display the cell address.
What is represented by the small black square in the lower-right corner of an active cell or range?
1.Copy handle
2.Fill handle
3.Insert handle
4.Border
What is the correct way to refer the cell A10 on sheet3 from sheet1?
1.sheet3!A10
2.sheet1!A10
3.Sheet3.A10
4.A10
What is the short cut key to highlight the entire column?
1.Ctrl+C
2.Ctrl+Enter
3.Ctrl+Page Up
4.Ctrl+Space Bar
What will be the output if you format the cell containing 5436.8 as ‘###0.00′?
1.5430
2.5436.8
3.5436.8
4.6.8
Which area in an Excel window allows entering values and formulas?
1.Title Bar
2.Menu Bar
3.Formula Bar
4.Standard Tool Bar
Which Chart can be created in Excel?
1.Area
2.Line
3.Pie
4.all of above
Which function is not available in the Consolidate dialog box?
1.Pmt
2.Average
3.Max
4.Sum
Which function is used to calculate depreciation rates of return future values and loan payment amounts?
1.Logical
2. Math & Trigonometry
3.Statistical
4.Financial
Which is not the function of “Edit Clear†command?
1.Delete contents
2.Delete notes
3.Delete cells
4.Delete formats
Which language is used to create macros in Excel?
1.Visual Basic
2.C
3.Visual C++
4.Java
Which of the following is not a term of MS-Excel?
1.Cells
2.Rows
3.Columns
4.Document
Which of the following is not a valid data type in Excel?
1.Number
2.Character
3.Label
4.Date/Time
Which setting you must modify to print a worksheet using letterhead?
1.Paper
2.Margin
3.Layout
4.Orientation
Which would you choose to create a bar diagram?
1.Edit Chart
2.Insert Chart
3.Tools Chart
4.Format Chart